Crea la tabla

CREATE OR REPLACE TABLE garas181.CANTANTES (
CODIGO NUMERIC (7, 0) GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
PAIS CHARACTER (03) NOT NULL WITH DEFAULT,
NOMBRE CHARACTER (50) NOT NULL WITH DEFAULT
)
RCDFMT REGI




Inserta registro al final

insert into garas181.sql001v02 (PAIS, NOMBRE)
VALUES ('ENG','THE POLICE');                 



Borra los registros con codigo mayor a 3

DELETE FROM GARAS181.SQL001V02 WHERE CODIGO > 0000003



Actualiza datos

UPDATE GARAS181.SQL001V02          
SET NOMBRE = 'LOS RODRIGUEZ'       
WHERE NOMBRE = 'RAPHAEL (EL NI#O)'